package com.decent.ejfadmin.ebitg.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.decent.ejfadmin.ebitg.dto.ChannelWithOperator;

@Mapper
public interface ChannelWithOperatorMapper {
	@Select("SELECT	channel.id `channel.id`, channel.name  `channel.name`,channel.STATUS `channel.STATUS`, channel.create_time, channel.update_time, channel.op_id,channel.COMMENT,"
			+ "  t2.id,	t2.opname,	t2.op_username,	t2.create_time,	t2.op_content"
			+ "  FROM zx_channel channel LEFT JOIN zx_oplog t2 ON ( channel.op_id = t2.id )")
//	@Results({ @Result(column = "channel.id", property = "channel.id") })
	public List<ChannelWithOperator> list();
}
